package sys.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;
import sys.entity.StuCount;
import sys.entity.StudentCount;
import sys.entity.StudentEntity;

import java.util.List;


@Mapper
@Repository
public interface StudentDao extends BaseMapper<StudentEntity> {

    List<StudentCount> getMaxScore();

    List<StudentCount> getMaxCourseScore();
    List<StudentCount> getSumStudentScore();

    List<StuCount> getMaxSumScore();

    List<StuCount> getMaxCourse();


    List<StuCount> totalScore();

    void addStudentTeacher(@Param("studentId")Integer studentId,@Param("teacherId")Integer teacherId);





}
